package com.yantong.pojo;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class AgentExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public AgentExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Long value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Long value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Long value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Long value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Long value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Long> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Long> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Long value1, Long value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Long value1, Long value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNull() {
            addCriterion("member_id is null");
            return (Criteria) this;
        }

        public Criteria andMemberIdIsNotNull() {
            addCriterion("member_id is not null");
            return (Criteria) this;
        }

        public Criteria andMemberIdEqualTo(Long value) {
            addCriterion("member_id =", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotEqualTo(Long value) {
            addCriterion("member_id <>", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThan(Long value) {
            addCriterion("member_id >", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdGreaterThanOrEqualTo(Long value) {
            addCriterion("member_id >=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThan(Long value) {
            addCriterion("member_id <", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdLessThanOrEqualTo(Long value) {
            addCriterion("member_id <=", value, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdIn(List<Long> values) {
            addCriterion("member_id in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotIn(List<Long> values) {
            addCriterion("member_id not in", values, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdBetween(Long value1, Long value2) {
            addCriterion("member_id between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberIdNotBetween(Long value1, Long value2) {
            addCriterion("member_id not between", value1, value2, "memberId");
            return (Criteria) this;
        }

        public Criteria andMemberNameIsNull() {
            addCriterion("member_name is null");
            return (Criteria) this;
        }

        public Criteria andMemberNameIsNotNull() {
            addCriterion("member_name is not null");
            return (Criteria) this;
        }

        public Criteria andMemberNameEqualTo(String value) {
            addCriterion("member_name =", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotEqualTo(String value) {
            addCriterion("member_name <>", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameGreaterThan(String value) {
            addCriterion("member_name >", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameGreaterThanOrEqualTo(String value) {
            addCriterion("member_name >=", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameLessThan(String value) {
            addCriterion("member_name <", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameLessThanOrEqualTo(String value) {
            addCriterion("member_name <=", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameLike(String value) {
            addCriterion("member_name like", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotLike(String value) {
            addCriterion("member_name not like", value, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameIn(List<String> values) {
            addCriterion("member_name in", values, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotIn(List<String> values) {
            addCriterion("member_name not in", values, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameBetween(String value1, String value2) {
            addCriterion("member_name between", value1, value2, "memberName");
            return (Criteria) this;
        }

        public Criteria andMemberNameNotBetween(String value1, String value2) {
            addCriterion("member_name not between", value1, value2, "memberName");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("name is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("name is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("name =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("name <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("name >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("name >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("name <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("name <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("name like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("name not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("name in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("name not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("name between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("name not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andContactsIsNull() {
            addCriterion("contacts is null");
            return (Criteria) this;
        }

        public Criteria andContactsIsNotNull() {
            addCriterion("contacts is not null");
            return (Criteria) this;
        }

        public Criteria andContactsEqualTo(String value) {
            addCriterion("contacts =", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotEqualTo(String value) {
            addCriterion("contacts <>", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThan(String value) {
            addCriterion("contacts >", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsGreaterThanOrEqualTo(String value) {
            addCriterion("contacts >=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThan(String value) {
            addCriterion("contacts <", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLessThanOrEqualTo(String value) {
            addCriterion("contacts <=", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsLike(String value) {
            addCriterion("contacts like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotLike(String value) {
            addCriterion("contacts not like", value, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsIn(List<String> values) {
            addCriterion("contacts in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotIn(List<String> values) {
            addCriterion("contacts not in", values, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsBetween(String value1, String value2) {
            addCriterion("contacts between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andContactsNotBetween(String value1, String value2) {
            addCriterion("contacts not between", value1, value2, "contacts");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andAreaIsNull() {
            addCriterion("area is null");
            return (Criteria) this;
        }

        public Criteria andAreaIsNotNull() {
            addCriterion("area is not null");
            return (Criteria) this;
        }

        public Criteria andAreaEqualTo(String value) {
            addCriterion("area =", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotEqualTo(String value) {
            addCriterion("area <>", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThan(String value) {
            addCriterion("area >", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaGreaterThanOrEqualTo(String value) {
            addCriterion("area >=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThan(String value) {
            addCriterion("area <", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLessThanOrEqualTo(String value) {
            addCriterion("area <=", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaLike(String value) {
            addCriterion("area like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotLike(String value) {
            addCriterion("area not like", value, "area");
            return (Criteria) this;
        }

        public Criteria andAreaIn(List<String> values) {
            addCriterion("area in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotIn(List<String> values) {
            addCriterion("area not in", values, "area");
            return (Criteria) this;
        }

        public Criteria andAreaBetween(String value1, String value2) {
            addCriterion("area between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andAreaNotBetween(String value1, String value2) {
            addCriterion("area not between", value1, value2, "area");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNull() {
            addCriterion("is_delete is null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNotNull() {
            addCriterion("is_delete is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteEqualTo(Integer value) {
            addCriterion("is_delete =", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotEqualTo(Integer value) {
            addCriterion("is_delete <>", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThan(Integer value) {
            addCriterion("is_delete >", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_delete >=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThan(Integer value) {
            addCriterion("is_delete <", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThanOrEqualTo(Integer value) {
            addCriterion("is_delete <=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIn(List<Integer> values) {
            addCriterion("is_delete in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotIn(List<Integer> values) {
            addCriterion("is_delete not in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteBetween(Integer value1, Integer value2) {
            addCriterion("is_delete between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotBetween(Integer value1, Integer value2) {
            addCriterion("is_delete not between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andProfitRateIsNull() {
            addCriterion("profit_rate is null");
            return (Criteria) this;
        }

        public Criteria andProfitRateIsNotNull() {
            addCriterion("profit_rate is not null");
            return (Criteria) this;
        }

        public Criteria andProfitRateEqualTo(BigDecimal value) {
            addCriterion("profit_rate =", value, "profitRate");
            return (Criteria) this;
        }

        public Criteria andProfitRateNotEqualTo(BigDecimal value) {
            addCriterion("profit_rate <>", value, "profitRate");
            return (Criteria) this;
        }

        public Criteria andProfitRateGreaterThan(BigDecimal value) {
            addCriterion("profit_rate >", value, "profitRate");
            return (Criteria) this;
        }

        public Criteria andProfitRateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("profit_rate >=", value, "profitRate");
            return (Criteria) this;
        }

        public Criteria andProfitRateLessThan(BigDecimal value) {
            addCriterion("profit_rate <", value, "profitRate");
            return (Criteria) this;
        }

        public Criteria andProfitRateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("profit_rate <=", value, "profitRate");
            return (Criteria) this;
        }

        public Criteria andProfitRateIn(List<BigDecimal> values) {
            addCriterion("profit_rate in", values, "profitRate");
            return (Criteria) this;
        }

        public Criteria andProfitRateNotIn(List<BigDecimal> values) {
            addCriterion("profit_rate not in", values, "profitRate");
            return (Criteria) this;
        }

        public Criteria andProfitRateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("profit_rate between", value1, value2, "profitRate");
            return (Criteria) this;
        }

        public Criteria andProfitRateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("profit_rate not between", value1, value2, "profitRate");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdIsNull() {
            addCriterion("branch_office_id is null");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdIsNotNull() {
            addCriterion("branch_office_id is not null");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdEqualTo(Long value) {
            addCriterion("branch_office_id =", value, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdNotEqualTo(Long value) {
            addCriterion("branch_office_id <>", value, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdGreaterThan(Long value) {
            addCriterion("branch_office_id >", value, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdGreaterThanOrEqualTo(Long value) {
            addCriterion("branch_office_id >=", value, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdLessThan(Long value) {
            addCriterion("branch_office_id <", value, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdLessThanOrEqualTo(Long value) {
            addCriterion("branch_office_id <=", value, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdIn(List<Long> values) {
            addCriterion("branch_office_id in", values, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdNotIn(List<Long> values) {
            addCriterion("branch_office_id not in", values, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdBetween(Long value1, Long value2) {
            addCriterion("branch_office_id between", value1, value2, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andBranchOfficeIdNotBetween(Long value1, Long value2) {
            addCriterion("branch_office_id not between", value1, value2, "branchOfficeId");
            return (Criteria) this;
        }

        public Criteria andLevelIsNull() {
            addCriterion("level is null");
            return (Criteria) this;
        }

        public Criteria andLevelIsNotNull() {
            addCriterion("level is not null");
            return (Criteria) this;
        }

        public Criteria andLevelEqualTo(Integer value) {
            addCriterion("level =", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotEqualTo(Integer value) {
            addCriterion("level <>", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelGreaterThan(Integer value) {
            addCriterion("level >", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("level >=", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelLessThan(Integer value) {
            addCriterion("level <", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelLessThanOrEqualTo(Integer value) {
            addCriterion("level <=", value, "level");
            return (Criteria) this;
        }

        public Criteria andLevelIn(List<Integer> values) {
            addCriterion("level in", values, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotIn(List<Integer> values) {
            addCriterion("level not in", values, "level");
            return (Criteria) this;
        }

        public Criteria andLevelBetween(Integer value1, Integer value2) {
            addCriterion("level between", value1, value2, "level");
            return (Criteria) this;
        }

        public Criteria andLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("level not between", value1, value2, "level");
            return (Criteria) this;
        }

        public Criteria andUpUserIdIsNull() {
            addCriterion("up_user_id is null");
            return (Criteria) this;
        }

        public Criteria andUpUserIdIsNotNull() {
            addCriterion("up_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpUserIdEqualTo(Long value) {
            addCriterion("up_user_id =", value, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserIdNotEqualTo(Long value) {
            addCriterion("up_user_id <>", value, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserIdGreaterThan(Long value) {
            addCriterion("up_user_id >", value, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("up_user_id >=", value, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserIdLessThan(Long value) {
            addCriterion("up_user_id <", value, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserIdLessThanOrEqualTo(Long value) {
            addCriterion("up_user_id <=", value, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserIdIn(List<Long> values) {
            addCriterion("up_user_id in", values, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserIdNotIn(List<Long> values) {
            addCriterion("up_user_id not in", values, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserIdBetween(Long value1, Long value2) {
            addCriterion("up_user_id between", value1, value2, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserIdNotBetween(Long value1, Long value2) {
            addCriterion("up_user_id not between", value1, value2, "upUserId");
            return (Criteria) this;
        }

        public Criteria andUpUserNameIsNull() {
            addCriterion("up_user_name is null");
            return (Criteria) this;
        }

        public Criteria andUpUserNameIsNotNull() {
            addCriterion("up_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andUpUserNameEqualTo(String value) {
            addCriterion("up_user_name =", value, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameNotEqualTo(String value) {
            addCriterion("up_user_name <>", value, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameGreaterThan(String value) {
            addCriterion("up_user_name >", value, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("up_user_name >=", value, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameLessThan(String value) {
            addCriterion("up_user_name <", value, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameLessThanOrEqualTo(String value) {
            addCriterion("up_user_name <=", value, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameLike(String value) {
            addCriterion("up_user_name like", value, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameNotLike(String value) {
            addCriterion("up_user_name not like", value, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameIn(List<String> values) {
            addCriterion("up_user_name in", values, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameNotIn(List<String> values) {
            addCriterion("up_user_name not in", values, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameBetween(String value1, String value2) {
            addCriterion("up_user_name between", value1, value2, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpUserNameNotBetween(String value1, String value2) {
            addCriterion("up_user_name not between", value1, value2, "upUserName");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdIsNull() {
            addCriterion("up_member_id is null");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdIsNotNull() {
            addCriterion("up_member_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdEqualTo(Long value) {
            addCriterion("up_member_id =", value, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdNotEqualTo(Long value) {
            addCriterion("up_member_id <>", value, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdGreaterThan(Long value) {
            addCriterion("up_member_id >", value, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdGreaterThanOrEqualTo(Long value) {
            addCriterion("up_member_id >=", value, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdLessThan(Long value) {
            addCriterion("up_member_id <", value, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdLessThanOrEqualTo(Long value) {
            addCriterion("up_member_id <=", value, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdIn(List<Long> values) {
            addCriterion("up_member_id in", values, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdNotIn(List<Long> values) {
            addCriterion("up_member_id not in", values, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdBetween(Long value1, Long value2) {
            addCriterion("up_member_id between", value1, value2, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberIdNotBetween(Long value1, Long value2) {
            addCriterion("up_member_id not between", value1, value2, "upMemberId");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameIsNull() {
            addCriterion("up_member_name is null");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameIsNotNull() {
            addCriterion("up_member_name is not null");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameEqualTo(String value) {
            addCriterion("up_member_name =", value, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameNotEqualTo(String value) {
            addCriterion("up_member_name <>", value, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameGreaterThan(String value) {
            addCriterion("up_member_name >", value, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameGreaterThanOrEqualTo(String value) {
            addCriterion("up_member_name >=", value, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameLessThan(String value) {
            addCriterion("up_member_name <", value, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameLessThanOrEqualTo(String value) {
            addCriterion("up_member_name <=", value, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameLike(String value) {
            addCriterion("up_member_name like", value, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameNotLike(String value) {
            addCriterion("up_member_name not like", value, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameIn(List<String> values) {
            addCriterion("up_member_name in", values, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameNotIn(List<String> values) {
            addCriterion("up_member_name not in", values, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameBetween(String value1, String value2) {
            addCriterion("up_member_name between", value1, value2, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUpMemberNameNotBetween(String value1, String value2) {
            addCriterion("up_member_name not between", value1, value2, "upMemberName");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdIsNull() {
            addCriterion("up2_user_id is null");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdIsNotNull() {
            addCriterion("up2_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdEqualTo(Long value) {
            addCriterion("up2_user_id =", value, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdNotEqualTo(Long value) {
            addCriterion("up2_user_id <>", value, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdGreaterThan(Long value) {
            addCriterion("up2_user_id >", value, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("up2_user_id >=", value, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdLessThan(Long value) {
            addCriterion("up2_user_id <", value, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdLessThanOrEqualTo(Long value) {
            addCriterion("up2_user_id <=", value, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdIn(List<Long> values) {
            addCriterion("up2_user_id in", values, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdNotIn(List<Long> values) {
            addCriterion("up2_user_id not in", values, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdBetween(Long value1, Long value2) {
            addCriterion("up2_user_id between", value1, value2, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserIdNotBetween(Long value1, Long value2) {
            addCriterion("up2_user_id not between", value1, value2, "up2UserId");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameIsNull() {
            addCriterion("up2_user_name is null");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameIsNotNull() {
            addCriterion("up2_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameEqualTo(String value) {
            addCriterion("up2_user_name =", value, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameNotEqualTo(String value) {
            addCriterion("up2_user_name <>", value, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameGreaterThan(String value) {
            addCriterion("up2_user_name >", value, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameGreaterThanOrEqualTo(String value) {
            addCriterion("up2_user_name >=", value, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameLessThan(String value) {
            addCriterion("up2_user_name <", value, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameLessThanOrEqualTo(String value) {
            addCriterion("up2_user_name <=", value, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameLike(String value) {
            addCriterion("up2_user_name like", value, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameNotLike(String value) {
            addCriterion("up2_user_name not like", value, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameIn(List<String> values) {
            addCriterion("up2_user_name in", values, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameNotIn(List<String> values) {
            addCriterion("up2_user_name not in", values, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameBetween(String value1, String value2) {
            addCriterion("up2_user_name between", value1, value2, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2UserNameNotBetween(String value1, String value2) {
            addCriterion("up2_user_name not between", value1, value2, "up2UserName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdIsNull() {
            addCriterion("up2_member_id is null");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdIsNotNull() {
            addCriterion("up2_member_id is not null");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdEqualTo(Long value) {
            addCriterion("up2_member_id =", value, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdNotEqualTo(Long value) {
            addCriterion("up2_member_id <>", value, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdGreaterThan(Long value) {
            addCriterion("up2_member_id >", value, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdGreaterThanOrEqualTo(Long value) {
            addCriterion("up2_member_id >=", value, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdLessThan(Long value) {
            addCriterion("up2_member_id <", value, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdLessThanOrEqualTo(Long value) {
            addCriterion("up2_member_id <=", value, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdIn(List<Long> values) {
            addCriterion("up2_member_id in", values, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdNotIn(List<Long> values) {
            addCriterion("up2_member_id not in", values, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdBetween(Long value1, Long value2) {
            addCriterion("up2_member_id between", value1, value2, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberIdNotBetween(Long value1, Long value2) {
            addCriterion("up2_member_id not between", value1, value2, "up2MemberId");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameIsNull() {
            addCriterion("up2_member_name is null");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameIsNotNull() {
            addCriterion("up2_member_name is not null");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameEqualTo(String value) {
            addCriterion("up2_member_name =", value, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameNotEqualTo(String value) {
            addCriterion("up2_member_name <>", value, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameGreaterThan(String value) {
            addCriterion("up2_member_name >", value, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameGreaterThanOrEqualTo(String value) {
            addCriterion("up2_member_name >=", value, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameLessThan(String value) {
            addCriterion("up2_member_name <", value, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameLessThanOrEqualTo(String value) {
            addCriterion("up2_member_name <=", value, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameLike(String value) {
            addCriterion("up2_member_name like", value, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameNotLike(String value) {
            addCriterion("up2_member_name not like", value, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameIn(List<String> values) {
            addCriterion("up2_member_name in", values, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameNotIn(List<String> values) {
            addCriterion("up2_member_name not in", values, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameBetween(String value1, String value2) {
            addCriterion("up2_member_name between", value1, value2, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp2MemberNameNotBetween(String value1, String value2) {
            addCriterion("up2_member_name not between", value1, value2, "up2MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdIsNull() {
            addCriterion("up3_user_id is null");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdIsNotNull() {
            addCriterion("up3_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdEqualTo(Long value) {
            addCriterion("up3_user_id =", value, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdNotEqualTo(Long value) {
            addCriterion("up3_user_id <>", value, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdGreaterThan(Long value) {
            addCriterion("up3_user_id >", value, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("up3_user_id >=", value, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdLessThan(Long value) {
            addCriterion("up3_user_id <", value, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdLessThanOrEqualTo(Long value) {
            addCriterion("up3_user_id <=", value, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdIn(List<Long> values) {
            addCriterion("up3_user_id in", values, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdNotIn(List<Long> values) {
            addCriterion("up3_user_id not in", values, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdBetween(Long value1, Long value2) {
            addCriterion("up3_user_id between", value1, value2, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserIdNotBetween(Long value1, Long value2) {
            addCriterion("up3_user_id not between", value1, value2, "up3UserId");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameIsNull() {
            addCriterion("up3_user_name is null");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameIsNotNull() {
            addCriterion("up3_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameEqualTo(String value) {
            addCriterion("up3_user_name =", value, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameNotEqualTo(String value) {
            addCriterion("up3_user_name <>", value, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameGreaterThan(String value) {
            addCriterion("up3_user_name >", value, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameGreaterThanOrEqualTo(String value) {
            addCriterion("up3_user_name >=", value, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameLessThan(String value) {
            addCriterion("up3_user_name <", value, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameLessThanOrEqualTo(String value) {
            addCriterion("up3_user_name <=", value, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameLike(String value) {
            addCriterion("up3_user_name like", value, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameNotLike(String value) {
            addCriterion("up3_user_name not like", value, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameIn(List<String> values) {
            addCriterion("up3_user_name in", values, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameNotIn(List<String> values) {
            addCriterion("up3_user_name not in", values, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameBetween(String value1, String value2) {
            addCriterion("up3_user_name between", value1, value2, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3UserNameNotBetween(String value1, String value2) {
            addCriterion("up3_user_name not between", value1, value2, "up3UserName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdIsNull() {
            addCriterion("up3_member_id is null");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdIsNotNull() {
            addCriterion("up3_member_id is not null");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdEqualTo(Long value) {
            addCriterion("up3_member_id =", value, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdNotEqualTo(Long value) {
            addCriterion("up3_member_id <>", value, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdGreaterThan(Long value) {
            addCriterion("up3_member_id >", value, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdGreaterThanOrEqualTo(Long value) {
            addCriterion("up3_member_id >=", value, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdLessThan(Long value) {
            addCriterion("up3_member_id <", value, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdLessThanOrEqualTo(Long value) {
            addCriterion("up3_member_id <=", value, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdIn(List<Long> values) {
            addCriterion("up3_member_id in", values, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdNotIn(List<Long> values) {
            addCriterion("up3_member_id not in", values, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdBetween(Long value1, Long value2) {
            addCriterion("up3_member_id between", value1, value2, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberIdNotBetween(Long value1, Long value2) {
            addCriterion("up3_member_id not between", value1, value2, "up3MemberId");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameIsNull() {
            addCriterion("up3_member_name is null");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameIsNotNull() {
            addCriterion("up3_member_name is not null");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameEqualTo(String value) {
            addCriterion("up3_member_name =", value, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameNotEqualTo(String value) {
            addCriterion("up3_member_name <>", value, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameGreaterThan(String value) {
            addCriterion("up3_member_name >", value, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameGreaterThanOrEqualTo(String value) {
            addCriterion("up3_member_name >=", value, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameLessThan(String value) {
            addCriterion("up3_member_name <", value, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameLessThanOrEqualTo(String value) {
            addCriterion("up3_member_name <=", value, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameLike(String value) {
            addCriterion("up3_member_name like", value, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameNotLike(String value) {
            addCriterion("up3_member_name not like", value, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameIn(List<String> values) {
            addCriterion("up3_member_name in", values, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameNotIn(List<String> values) {
            addCriterion("up3_member_name not in", values, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameBetween(String value1, String value2) {
            addCriterion("up3_member_name between", value1, value2, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andUp3MemberNameNotBetween(String value1, String value2) {
            addCriterion("up3_member_name not between", value1, value2, "up3MemberName");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createtime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createtime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createtime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createtime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createtime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createtime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createtime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createtime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createtime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createtime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createtime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createtime not between", value1, value2, "createtime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}